﻿CREATE TABLE [dbo].[PiPlatFormAddIn] (
    [Id]            INT             IDENTITY (1, 1) NOT NULL,
    [Guid]          NVARCHAR (40)   NOT NULL,
    [Name]          NVARCHAR (100)  NOT NULL,
    [AssemblyName]  NVARCHAR (100)  NOT NULL,
    [ClassName]     NVARCHAR (100)  NOT NULL,
    [AddIn]         VARBINARY (MAX) NULL,
    [AddInSize]     FLOAT (53)      CONSTRAINT [DF__PiPlatFor__AddIn__1E05700A] DEFAULT ((0)) NULL,
    [Version]       NVARCHAR (30)   NOT NULL,
    [Developer]     NVARCHAR (300)  NULL,
    [DownLoadCount] INT             CONSTRAINT [DF_PiPlatFormAddIn_DownLoadCount] DEFAULT ((0)) NULL,
    [Enabled]       INT             CONSTRAINT [DF_PiPlatFormAddIn_Enabled] DEFAULT ((1)) NOT NULL,
    [DeleteMark]    INT             CONSTRAINT [DF_PiPlatFormAddIn_DeleteMark] DEFAULT ((0)) NOT NULL,
    [Description]   NVARCHAR (500)  NULL,
    [CreateOn]      DATETIME        CONSTRAINT [DF__PiPlatFor__Creat__1EF99443] DEFAULT (getdate()) NULL,
    [CreateUserId]  NVARCHAR (50)   NULL,
    [CreateBy]      NVARCHAR (50)   NULL,
    [ModifiedOn]    DATETIME        NULL,
    [ModifyUserId]  NVARCHAR (50)   NULL,
    [ModifiedBy]    NVARCHAR (50)   NULL,
    CONSTRAINT [PK_PIPLATFORMADDIN] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [Index_Assembly]
    ON [dbo].[PiPlatFormAddIn]([AssemblyName] ASC);

